package atguigu.sql;

import cn.hutool.core.io.FileUtil;

import java.io.File;
import java.util.ArrayList;
import java.util.List;

public class Demo2 {

    public static void main(String[] args) {
        String[] strs = new String[]{"5062303770739",
                "5062303770740",
                "5062303770741",
                "5062303770742",
                "5062303770743",
                "5062303770744",
                "5062303770745",
                "5062303770746",
                "5062303770747",
                "5062303770748",
                "5062303770749",
                "5062303770750",
                "5062303770751",
                "5062303770752",
                "5062303770753",
                "5062303770754",
                "5062303770755",
                "5062303770756",
                "5062303770757",
                "5062303770758",
                "5062303770759",
                "5062303770760",
                "5062303770761",
                "5062303770762",
                "5062303770763",
                "5062303770764",
                "5062303770765",
                "5062303770766",
                "5062303770767",
                "5062303770768",
                "5062303770769",
                "5062303770770",
                "5062303770771",
                "5062303770772",
                "5062303770773",
                "5062303770774",
                "5062303770775",
                "5062303770776",
                "5062303770777",
                "5062303770778",
                "5062303770779",
                "5062303770780",
                "5062303770781",
                "5062303770782",
                "5062303770783",
                "5062303770784",
                "5062303770785",
                "5062303770786",
                "5062303770787",
                "5062303770788",
                "5062303770789",
                "5062303770790",
                "5062303770791",
                "5062303770792",
                "5062303770793",
                "5062303770794",
                "5062303770795",
                "5062303770796",
                "5062303770797",
                "5062303770798",
                "5062303770799",
                "5062303770800",
                "5062303770801",
                "5062303770802",
                "5062303770803",
                "5062303770804",
                "5062303770805",
                "5062303770806",
                "5062303770807",
                "5062303770808",
                "5062303770809",
                "5062303770810",
                "5062303770811",
                "5062303770812",
                "5062303770813",
                "5062303770814",
                "5062303770815",
                "5062303770816",
                "5062303770817",
                "5062303770818",
                "5062303770819",
                "5062303770820",
                "5062303770821",
                "5062303770822",
                "5062303770823",
                "5062303770824",
                "5062303770825",
                "5062303770826",
                "5062303770827",
                "5062303770828",
                "5062303770829",
                "5062303770830",
                "5062303770831",
                "5062303770832",
                "5062303770833",
                "5062303770834",
                "5062303770835",
                "5062303770836",
                "5062303770837",
                "5062303770838",
                "5062303770839",
                "5062303770840",
                "5062303770841",
                "5062303770842",
                "5062303770843",
                "5062303770844",
                "5062303770845",
                "5062303770846",
                "5062303770847",
                "5062303770848",
                "5062303770849",
                "5062303770850",
                "5062303770851",
                "5062303770852",
                "5062303770853",
                "5062303770854",
                "5062303770855",
                "5062303770856",
                "5062303770857",
                "5062303770858",
                "5062303770859",
                "5062303770860",
                "5062303770861",
                "5062303770862",
                "5062303770863",
                "5062303770864",
                "5062303770865",
                "5062303770866",
                "5062303770867",
                "5062303770868",
                "5062303770869",
                "5062303770870",
                "5062303770871",
                "5062303770872",
                "5062303770873",
                "5062303770874",
                "5062303770875",
                "5062303770876",
                "5062303770877",
                "5062303770878",
                "5062303770879",
                "5062303770880",
                "5062303770881",
                "5062303770882",
                "5062303770883",
                "5062303770884",
                "5062303770885",
                "5062303770886",
                "5062303770887",
                "5062303770888",
                "5062303770889",
                "5062303770890",
                "5062303770891",
                "5062303770892",
                "5062303770893",
                "5062303770894",
                "5062303770895",
                "5062303770896",
                "5062303770897",
                "5062303770898",
                "5062303770899",
                "5062303770900",
                "5062303770901",
                "5062303770902",
                "5062303770903",
                "5062303770904",
                "5062303770905",
                "5062303770906",
                "5062303770907",
                "5062303770908",
                "5062303770909",
                "5062303770910",
                "5062303770911",
                "5062303770912",
                "5062303770913",
                "5062303770914",
                "5062303770915",
                "5062303770916",
                "5062303770917",
                "5062303770918",
                "5062303770919",
                "5062303770920",
                "5062303770921",
                "5062303770922",
                "5062303770923",
                "5062303770924",
                "5062303770925",
                "5062303770926",
                "5062303770927",
                "5062303770928",
                "5062303770929",
                "5062303770930",
                "5062303770931",
                "5062303770932",
                "5062303770933",
                "5062303770934",
                "5062303770935",
                "5062303770936",
                "5062303770937",
                "5062303770938",
                "5062303770939",
                "5062303770940",
                "5062303770941",
                "5062303770942",
                "5062303770943",
                "5062303770944",
                "5062303770945",
                "5062303770946",
                "5062303770947",
                "5062303770948",
                "5062303770949",
                "5062303770950",
                "5062303770951",
                "5062303770952",
                "5062303770953",
                "5062303770954",
                "5062303770955",
                "5062303770956",
                "5062303770957",
                "5062303770958",
                "5062303770959",
                "5062303770960",
                "5062303770961",
                "5062303770962",
                "5062303770963",
                "5062303770964",
                "5062303770965",
                "5062303770966",
                "5062303770967",
                "5062303770968",
                "5062303770969",
                "5062303770970",
                "5062303770971",
                "5062303770972",
                "5062303770973",
                "5062303770974",
                "5062303770975",
                "5062303770976",
                "5062303770977",
                "5062303770978",
                "5062303770979",
                "5062303770980",
                "5062303770981",
                "5062303770982",
                "5062303770983",
                "5062303770984",
                "5062303770985"};

        String[] strs2 = new String[]{"2000000000017",
                "2000000000018",
                "2000000000019",
                "2000000000020",
                "2000000000021",
                "2000000000022",
                "2000000000023"};

        long oid = 4105032773665l;

        List<String> list = new ArrayList<>();
        for (String str : strs) {
            for (String s : strs2) {
                String sql =
                        "INSERT INTO midea_lims_new.accuracylink"+
                                "(oid, createTime, editTime, roleA, roleAClass, roleB, roleBClass)"+
                                "VALUES("+oid+", '2022-08-25 11:02:03.000', '2022-08-25 11:02:03.000', "+str+", 'com.midea.ext.model.accuracy.AccuracyCheckParam', "+s+", 'com.midea.ext.model.accuracy.AccuracyType');";


                list.add(sql);
                oid+=1;
            }
        }

        System.out.println(list.size());
        FileUtil.writeLines(list,new File("d:/sql22.txt"),"UTF-8");

    }
}
